CREATE DATABASE  IF NOT EXISTS `poslovanje` /*!40100 DEFAULT CHARACTER SET utf8 */;
USE `poslovanje`;
-- MySQL dump 10.13  Distrib 5.5.16, for Win32 (x86)
--
-- Host: localhost    Database: poslovanje
-- ------------------------------------------------------
-- Server version	5.5.25

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `detalji_fakture`
--

DROP TABLE IF EXISTS `detalji_fakture`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `detalji_fakture` (
  `id` mediumint(8) unsigned NOT NULL AUTO_INCREMENT,
  `faktura` smallint(5) unsigned NOT NULL,
  `red_br` tinyint(3) unsigned NOT NULL,
  `proizvod` tinyint(3) unsigned NOT NULL,
  `kolicina` decimal(8,2) NOT NULL,
  `dan_cena` decimal(8,2) NOT NULL,
  PRIMARY KEY (`id`),
  KEY `k_proizvod` (`proizvod`),
  KEY `k_faktura` (`faktura`),
  CONSTRAINT `fk_detalji_fakture_proizvodi` FOREIGN KEY (`proizvod`) REFERENCES `proizvodi` (`maticni_broj`) ON DELETE CASCADE ON UPDATE CASCADE,
  CONSTRAINT `fk_detalji_fakture_fakture` FOREIGN KEY (`faktura`) REFERENCES `fakture` (`sifra_fakture`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB AUTO_INCREMENT=31 DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `detalji_fakture`
--

LOCK TABLES `detalji_fakture` WRITE;
/*!40000 ALTER TABLE `detalji_fakture` DISABLE KEYS */;
INSERT INTO `detalji_fakture` VALUES (1,1,1,3,50.00,200.00),(2,2,1,5,50.00,25.00),(3,2,2,6,35.00,60.00),(4,2,3,3,40.00,220.00),(5,3,1,1,20.00,75.00),(6,3,2,2,35.00,300.00),(7,3,3,3,60.00,200.00),(8,3,4,4,50.00,170.00),(9,4,1,4,50.00,190.00),(10,4,2,1,50.00,80.00),(11,5,1,5,120.00,20.00),(12,5,2,4,100.00,150.00),(13,5,3,6,25.00,80.00),(14,6,1,4,75.00,200.00),(15,6,2,6,50.00,85.00),(16,6,3,2,24.00,330.00),(17,6,4,3,70.00,230.00),(18,6,5,5,80.00,30.00),(19,7,1,2,26.00,310.00),(20,8,1,6,45.00,65.00),(21,8,2,3,50.00,250.00),(22,9,1,1,50.00,70.00),(23,9,2,5,25.00,25.00),(24,9,3,2,14.00,320.00),(25,10,1,4,150.00,210.00),(26,10,2,5,200.00,35.00),(27,10,3,1,125.00,90.00),(28,10,4,2,100.00,280.00),(29,10,5,6,60.00,55.00),(30,11,1,1,5.00,75.00);
/*!40000 ALTER TABLE `detalji_fakture` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `fakture`
--

DROP TABLE IF EXISTS `fakture`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `fakture` (
  `sifra_fakture` smallint(5) unsigned NOT NULL,
  `sifra_firme` tinyint(3) unsigned NOT NULL,
  `datum` date NOT NULL,
  `ulaz_izlaz` char(1) NOT NULL,
  PRIMARY KEY (`sifra_fakture`),
  KEY `k_sifra_firme` (`sifra_firme`),
  CONSTRAINT `fk_fakture_firme` FOREIGN KEY (`sifra_firme`) REFERENCES `firme` (`firma`) ON DELETE CASCADE ON UPDATE CASCADE
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `fakture`
--

LOCK TABLES `fakture` WRITE;
/*!40000 ALTER TABLE `fakture` DISABLE KEYS */;
INSERT INTO `fakture` VALUES (1,2,'2006-10-25','1'),(2,4,'2006-10-28','1'),(3,1,'2006-10-25','2'),(4,3,'2006-10-29','2'),(5,3,'2006-10-25','1'),(6,1,'2006-11-06','2'),(7,4,'2006-11-04','2'),(8,2,'2006-10-23','1'),(9,1,'2006-11-02','2'),(10,4,'2006-10-08','1'),(11,3,'2006-10-15','1');
/*!40000 ALTER TABLE `fakture` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `firme`
--

DROP TABLE IF EXISTS `firme`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `firme` (
  `firma` tinyint(3) unsigned NOT NULL,
  `naziv_firme` varchar(100) NOT NULL,
  `mesto` varchar(50) DEFAULT NULL,
  `adresa` varchar(50) DEFAULT NULL,
  `telefon` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`firma`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `firme`
--

LOCK TABLES `firme` WRITE;
/*!40000 ALTER TABLE `firme` DISABLE KEYS */;
INSERT INTO `firme` VALUES (1,'BALKAN','Niš','Mokranjčeva 13','018-522-854'),(2,'STIL','Beograd','Takovska 10','011-562-365'),(3,'KOKOMAX','Niš','Dušanova 33','018-352-666'),(4,'HELIO','Subotica','Nikole Tesle 55','027-555-125');
/*!40000 ALTER TABLE `firme` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `proizvodi`
--

DROP TABLE IF EXISTS `proizvodi`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `proizvodi` (
  `maticni_broj` tinyint(3) unsigned NOT NULL,
  `ime` varchar(50) NOT NULL,
  `jed_mere` varchar(20) DEFAULT NULL,
  PRIMARY KEY (`maticni_broj`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `proizvodi`
--

LOCK TABLES `proizvodi` WRITE;
/*!40000 ALTER TABLE `proizvodi` DISABLE KEYS */;
INSERT INTO `proizvodi` VALUES (1,'Četka','kom.'),(2,'Lak','lit.'),(3,'Stiropor','m2'),(4,'Gips','kg'),(5,'Destilovana voda','kg'),(6,'Šmirgla','kom.');
/*!40000 ALTER TABLE `proizvodi` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2013-05-07 21:30:50